﻿CREATE TABLE [dbo].[Forsamling] (
    [Id]           UNIQUEIDENTIFIER NOT NULL,
    [ValId]        UNIQUEIDENTIFIER NOT NULL,
    [Skapad]       DATETIME         NOT NULL,
    [SkapadAv]     NVARCHAR (50)    NOT NULL,
    [Andrad]       DATETIME         NULL,
    [AndradAv]     NVARCHAR (50)    NULL,
    [Benamning]    NVARCHAR (50)    NOT NULL,
    [ValkretsId]   UNIQUEIDENTIFIER NOT NULL,
    [ForsamlingNr] NVARCHAR (50)    NULL,
    CONSTRAINT [PK_Forsamling] PRIMARY KEY CLUSTERED ([Id] ASC, [ValId] ASC),
    CONSTRAINT [FK_Forsamling_Valkrets] FOREIGN KEY ([ValkretsId], [ValId]) REFERENCES [dbo].[Valkrets] ([Id], [ValId])
);







